package top.fyxxxx.dbdesign.dao;

public class Main {
    public static void main(String[] args) {
        System.out.print("CREATE TABLE IF NOT EXISTS signIn(\n" +
                "   uid BIGINT NOT NULL,\n" +
                "   cid BIGINT NOT NULL,\n" +
                "   sid BIGINT NOT NULL,\n" +
                "   sidate timestamp NOT NULL,\n"+
                "   PRIMARY KEY ( uid,sid ),\n" +
                "   INDEX( cid ),\n" +
                "   INDEX( uid ) \n" +
                ")ENGINE=InnoDB DEFAULT CHARSET=utf8;");
    }
}
